[dbo].[asi_FindLastReceiptDateForContact]

SQLServer > iMIS1521GA > Stored Procedures > dbo.asi_FindLastReceiptDateForContact

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@contactKey	uniqueidentifier	16

SQL Script

CREATE PROCEDURE [dbo].[asi_FindLastReceiptDateForContact]
@contactKey uniqueidentifier

AS

SELECT TOP 1 r.IssuedOn FROM ReceiptMain r
WHERE r.IssuedToContactKey = @contactKey
ORDER BY r.IssuedOn DESC

GO

Uses

[dbo].[ReceiptMain]
dbo